QA/QC Module

## Relative path to the file: ./data/BBC_Example_Data_QC_Module.xlsx
## Warning: Expecting numeric in N2772 / R2772C14: got 'BDL'
## Warning: Expecting numeric in N2776 / R2776C14: got 'BDL'
## Warning: Expecting logical in AD7774 / R7774C30: got 'Here DO logger flipped
## upsidedown to minimize fouling by TW'
## # A tibble: 6 × 31
##   Line_Num Stn_ID SAMP_DATE           SAMP_DATE_TIME       YEAR UniqueID  GEN_QC
##      <dbl> <chr>  <dttm>              <dttm>              <dbl> <chr>      <dbl>
## 1        1 SR4    2022-06-09 12:00:00 2022-06-09 12:00:00  2022 SR4_2022…     12
## 2        2 SR4    2022-06-09 12:15:00 2022-06-09 12:15:00  2022 SR4_2022…     NA
## 3        3 SR4    2022-06-09 12:30:00 2022-06-09 12:30:00  2022 SR4_2022…     NA
## 4        4 SR4    2022-06-09 12:45:00 2022-06-09 12:45:00  2022 SR4_2022…     NA
## 5        5 SR4    2022-06-09 13:00:00 2022-06-09 13:00:00  2022 SR4_2022…     NA
## 6        6 SR4    2022-06-09 13:15:00 2022-06-09 13:15:00  2022 SR4_2022…     NA
## # ℹ 24 more variables: TIME <dttm>, Time_QC <lgl>, Temp_C_DOlogger <dbl>,
## #   TEMP_QC_DOlogger <lgl>, Temp_C_condlogger <dbl>, TEMP_QC_condlogger <lgl>,
## #   DO_mgl <dbl>, DO_QC <dbl>, DO_mgl_adj <dbl>, DO_adj_QC <dbl>,
## #   DO_adj_QC_CALIBRATION <lgl>, `DO_% Sat` <dbl>, `DO%Sat_QC` <dbl>,
## #   Sal_ppt <dbl>, Sal_QC <lgl>, Sal_QC_CALIBRATION <dbl>,
## #   `High Range, μS/cm` <dbl>, HighRange_QC <lgl>, SpecCon <dbl>,
## #   SpecCon_QC <lgl>, `Serial number_DOlogger` <dbl>, …
## # A tibble: 6 × 32
##   Line_Num Stn_ID SAMP_DATE           SAMP_DATE_TIME       YEAR UniqueID  GEN_QC
##      <dbl> <chr>  <dttm>              <dttm>              <dbl> <chr>      <dbl>
## 1        1 SR4    2022-06-09 12:00:00 2022-06-09 12:00:00  2022 SR4_2022…     12
## 2        2 SR4    2022-06-09 12:15:00 2022-06-09 12:15:00  2022 SR4_2022…     NA
## 3        3 SR4    2022-06-09 12:30:00 2022-06-09 12:30:00  2022 SR4_2022…     NA
## 4        4 SR4    2022-06-09 12:45:00 2022-06-09 12:45:00  2022 SR4_2022…     NA
## 5        5 SR4    2022-06-09 13:00:00 2022-06-09 13:00:00  2022 SR4_2022…     NA
## 6        6 SR4    2022-06-09 13:15:00 2022-06-09 13:15:00  2022 SR4_2022…     NA
## # ℹ 25 more variables: TIME <dttm>, Time_QC <lgl>, Temp_C_DOlogger <dbl>,
## #   TEMP_QC_DOlogger <lgl>, Temp_C_condlogger <dbl>, TEMP_QC_condlogger <lgl>,
## #   DO_mgl <dbl>, DO_QC <lgl>, DO_mgl_adj <dbl>, DO_adj_QC <dbl>,
## #   DO_adj_QC_CALIBRATION <lgl>, `DO_% Sat` <dbl>, `DO%Sat_QC` <dbl>,
## #   Sal_ppt <dbl>, Sal_QC <lgl>, Sal_QC_CALIBRATION <dbl>,
## #   `High Range, μS/cm` <dbl>, HighRange_QC <lgl>, SpecCon <dbl>,
## #   SpecCon_QC <lgl>, `Serial number_DOlogger` <dbl>, …

Salinity ranges used

## # A tibble: 6 × 37
##   Line_Num Stn_ID SAMP_DATE           SAMP_DATE_TIME       YEAR UniqueID  GEN_QC
##      <dbl> <chr>  <dttm>              <dttm>              <dbl> <chr>      <dbl>
## 1        1 SR4    2022-06-09 12:00:00 2022-06-09 12:00:00  2022 SR4_2022…     12
## 2        2 SR4    2022-06-09 12:15:00 2022-06-09 12:15:00  2022 SR4_2022…     NA
## 3        3 SR4    2022-06-09 12:30:00 2022-06-09 12:30:00  2022 SR4_2022…     NA
## 4        4 SR4    2022-06-09 12:45:00 2022-06-09 12:45:00  2022 SR4_2022…     NA
## 5        5 SR4    2022-06-09 13:00:00 2022-06-09 13:00:00  2022 SR4_2022…     NA
## 6        6 SR4    2022-06-09 13:15:00 2022-06-09 13:15:00  2022 SR4_2022…     NA
## # ℹ 30 more variables: TIME <dttm>, Time_QC <lgl>, Temp_C_DOlogger <dbl>,
## #   TEMP_QC_DOlogger <lgl>, Temp_C_condlogger <dbl>, TEMP_QC_condlogger <lgl>,
## #   DO_mgl <dbl>, DO_QC <lgl>, DO_mgl_adj <dbl>, DO_adj_QC <dbl>,
## #   DO_adj_QC_CALIBRATION <lgl>, `DO_% Sat` <dbl>, `DO%Sat_QC` <dbl>,
## #   Sal_ppt <dbl>, Sal_QC <lgl>, Sal_QC_CALIBRATION <dbl>,
## #   `High Range, μS/cm` <dbl>, HighRange_QC <lgl>, SpecCon <dbl>,
## #   SpecCon_QC <lgl>, `Serial number_DOlogger` <dbl>, …

Plots

Interactive Plots

## Warning in RColorBrewer::brewer.pal(N, "Set2"): minimal value for n is 3, returning requested palette with 3 different levels

## Warning in RColorBrewer::brewer.pal(N, "Set2"): minimal value for n is 3, returning requested palette with 3 different levels